package com.tengju.data.infrastructure.persistence.mybatis.mapper.clickhouse.ods;

import org.apache.ibatis.annotations.Param;

import java.time.LocalDateTime;
import java.util.List;
import java.util.Map;

public interface OdsBigDataAchievementBonusDiDMapper {

    List<Map<String,Object>> getMonthMarketClassifyRatio(@Param("startVisitDate") String startVisitDate,
                                                   @Param("endVisitDate") String endVisitDate,
                                                   @Param("idCode") Long idCode);

    List<Map<String, Object>> getMonthDateMarketTendency(@Param("startVisitDate") String startVisitDate,
                                                         @Param("endVisitDate") String endVisitDate,
                                                         @Param("idCode") Long idCode);

    List<Map<String,Object>> getMonthDateMarketDetail(@Param("startVisitDate") String startVisitDate,
                                                      @Param("endVisitDate") String endVisitDate,
                                                      @Param("idCode") Long idCode);

    List<Map<String,Object>> getYearMonthMarketTendency(@Param("yearStartMonth") Integer yearStartMonth,
                                                        @Param("yearEndMonth") Integer yearEndMonth,
                                                        @Param("idCode") Long idCode);

    Map<String,Object> getMonthAdvertiseIndex(@Param("startVisitDate") String startVisitDate,
                                              @Param("endVisitDate") String endVisitDate,
                                              @Param("idCode") Long idCode);

    List<Map<String,Object>> getIndexByTeamRatioType(@Param("startVisitDate") String startVisitDate,
                                                     @Param("endVisitDate") String endVisitDate,
                                                     @Param("idCode") Long idCode);

    Map<String,Object> getUpdateTime(@Param("idCode") Long idCode);


}
